Main
Dingrui(Frank) Zhang
Data Analyst | Accountant
I enjoy working with data to solve business problems and build tools that help people. My favorite part of working in both data and finance area is the constant opportunity to learn, from statistics and software development to real business problems as well as to use tools to communicate insights with people and help them make decisions.
Education
Master of Professional Accounting
University of New South Wales
Sydney, Australia
2019 - 2017
Exchange Student Program (Major in Accounting)
University of New South Wales
Sydney, Australia
2017 - 2016
- Achieved Overall Distinction WAM
Bachelor of Management (Major in Accounting)
Hebei University of Economics and Business
Shijiazhuang, China
2016 - 2013
- Achieved Overall WAM of 80
Professional Experience
Consultant, Data Analytics
PwC Australia
Sydney, Australia
Present - 2020 Jan
- Worked on data analysis and visualisation, and bring data analytic techniques to bear on a wide variety of problems.
- Utilised data analysis and visualisation techniques to provide clients with powerful business insight regarding their data. This would in turn help them make informed business decisions. Tools used include Alteryx, SQL, Power BI, Tableau and Qlik Sense.
- Developed and maintained easy-to-use product and provided training and documentation for both internal and external parties. Tools used include: Google App Script, Python and VBA
- Played a key role in mapping the existing business process of the organization with respect to data governance and management and suggesting appropriate business practices to modify them to meet their requirements.
- Attended meetings with multiple project stakeholders including internal and external clients to gather and document detailed data requirements.
Finance Analyst
The University of Sydney
Sydney, Australia
2019 Dec - 2019 Aug
- Designed, developed and maintained standardized budget/forecast models, tools and guidelines to improve the accuracy, consistency, timeliness and quality of budgeting and forecasting throughout the Faculties and these are continued to be used across the University faculties.
- Performed variance analysis, trend analysis and sensitivity analysis on daily requests. Assisting Senior Financial Analyst in providing insightful analysis, to track and report financial and non-financial KPIs.
- Improved reporting pipelines utilising VBA , SmartView and R to automate processes and provide high-level quality controls.
- Migrated monthly financial reporting dashboards from excel-based to Power BI. The migration saved more than 50% time comparing with excel-based method
- Assisted with the preparation of reconciliations of financial and operational data from different sources and provided recommendations to Finance Managers and Head of Schools
Data Analyst Intern
Travelzoo (NASDAQ: TZOO)
Sydney, Australia
2019 Aug - 2018 Dec
- Developed an automated program (web scraper) that identifies and stores the marketing data in database to produce the desired reports.
- Developed multiple macros and R scripts to collect information from multiple sources(ERP, Excel, Text …), analyse data and generate report automatically. Saved more than 50% time.
- Collected and maintained history operation database and built up weekly operation report for the whole APAC(Asia Pacific) area.
- Provided operations support for APAC Team, for example: overseas collection deal price point conversion.
- Built quarterly/monthly dashboard for different countries in APAC area which provided measurements for management.
Junior Financial Analyst
UBI Logistics (Australia) Pty Ltd
Sydney, Australia
2018 Sep - 2017 Aug
- Developed a billing system based on VBA and R which supports generating billing statements, email automation and aging analysis. This system significantly freed people from heavy and routine manual work, reduced 2 FTE (Full-time equivalent) and improved collecting accounts receivable.
- Developed a procedure to analyse data, identify discrepancies and design reporting mechanism, which allow on-time and accurate measure of the company performance. This procedure is still utilized and has been able to recover more than 120,000 AUD in the past 1 year, which otherwise would be lost because of the information inaccuracy.
- Built and maintained a MySQL finance database which helps finance department find discrepancies between forecast and real-time data, also responsible for designing data tables, managing permissions and setting up backups.
- Worked as a consultant with a team of 5 co-workers from both China and Australia to establish an online invoicing system and successfully coordinated the project between finance and IT team.
Professional Development
Provisional member of Chartered Accountants ANZ
N/A
N/A
Present - 2019 Aug
26 R Courses on Datacamp
Datacamp (Click here to see the list)
Courses include:
N/A
Present - 2017 Aug
- Cleansing, Transformation and Visualization of data
- Reporting and Visualization using Rmarkdown, ggplot2 and Shiny
- Webscraping with R
- Use SQL in R